﻿CREATE FUNCTION [dbo].[MakeName] 
(
	@FirstName nvarchar(50),
	@LastName nvarchar(50)
)
RETURNS nvarchar(100)
AS
BEGIN
	RETURN rtrim( coalesce( @FirstName, '' ) ) + ' ' + rtrim( coalesce( @LastName, '' ) )
END